{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Combine Multiple Excel Worksheets Into a Single Pandas Dataframe\n",
    "\n",
    "Article posted [here](https://pbpython.com/pandas-excel-tabs.html)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "workbook_url = 'https://github.com/chris1610/pbpython/raw/master/data/2018_Sales_Total_Tabs.xlsx'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "single_df =  pd.read_excel(workbook_url, sheet_name='Sheet1')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>account number</th>\n",
       "      <th>name</th>\n",
       "      <th>sku</th>\n",
       "      <th>quantity</th>\n",
       "      <th>unit price</th>\n",
       "      <th>ext price</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>412290</td>\n",
       "      <td>Jerde-Hilpert</td>\n",
       "      <td>S2-77896</td>\n",
       "      <td>43</td>\n",
       "      <td>76.66</td>\n",
       "      <td>3296.38</td>\n",
       "      <td>2018-03-04 23:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>383080</td>\n",
       "      <td>Will LLC</td>\n",
       "      <td>S1-93683</td>\n",
       "      <td>28</td>\n",
       "      <td>90.86</td>\n",
       "      <td>2544.08</td>\n",
       "      <td>2018-03-05 05:11:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>729833</td>\n",
       "      <td>Koepp Ltd</td>\n",
       "      <td>S1-30248</td>\n",
       "      <td>13</td>\n",
       "      <td>44.84</td>\n",
       "      <td>582.92</td>\n",
       "      <td>2018-03-05 17:33:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>424914</td>\n",
       "      <td>White-Trantow</td>\n",
       "      <td>S2-82423</td>\n",
       "      <td>38</td>\n",
       "      <td>50.93</td>\n",
       "      <td>1935.34</td>\n",
       "      <td>2018-03-05 21:40:10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>672390</td>\n",
       "      <td>Kuhn-Gusikowski</td>\n",
       "      <td>S1-50961</td>\n",
       "      <td>34</td>\n",
       "      <td>48.20</td>\n",
       "      <td>1638.80</td>\n",
       "      <td>2018-03-06 11:59:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   account number             name       sku  quantity  unit price  ext price  \\\n",
       "0          412290    Jerde-Hilpert  S2-77896        43       76.66    3296.38   \n",
       "1          383080         Will LLC  S1-93683        28       90.86    2544.08   \n",
       "2          729833        Koepp Ltd  S1-30248        13       44.84     582.92   \n",
       "3          424914    White-Trantow  S2-82423        38       50.93    1935.34   \n",
       "4          672390  Kuhn-Gusikowski  S1-50961        34       48.20    1638.80   \n",
       "\n",
       "                 date  \n",
       "0 2018-03-04 23:10:28  \n",
       "1 2018-03-05 05:11:49  \n",
       "2 2018-03-05 17:33:52  \n",
       "3 2018-03-05 21:40:10  \n",
       "4 2018-03-06 11:59:00  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "single_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "all_dfs = pd.read_excel(workbook_url, sheet_name=None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "collections.OrderedDict"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(all_dfs)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "collections.OrderedDict"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(all_dfs)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "odict_keys(['Sheet1', 'Sheet2', 'Sheet3', 'Sheet4', 'Sheet5', 'Sheet6'])"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_dfs.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>account number</th>\n",
       "      <th>name</th>\n",
       "      <th>sku</th>\n",
       "      <th>quantity</th>\n",
       "      <th>unit price</th>\n",
       "      <th>ext price</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>412290</td>\n",
       "      <td>Jerde-Hilpert</td>\n",
       "      <td>S2-77896</td>\n",
       "      <td>43</td>\n",
       "      <td>76.66</td>\n",
       "      <td>3296.38</td>\n",
       "      <td>2018-03-04 23:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>383080</td>\n",
       "      <td>Will LLC</td>\n",
       "      <td>S1-93683</td>\n",
       "      <td>28</td>\n",
       "      <td>90.86</td>\n",
       "      <td>2544.08</td>\n",
       "      <td>2018-03-05 05:11:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>729833</td>\n",
       "      <td>Koepp Ltd</td>\n",
       "      <td>S1-30248</td>\n",
       "      <td>13</td>\n",
       "      <td>44.84</td>\n",
       "      <td>582.92</td>\n",
       "      <td>2018-03-05 17:33:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>424914</td>\n",
       "      <td>White-Trantow</td>\n",
       "      <td>S2-82423</td>\n",
       "      <td>38</td>\n",
       "      <td>50.93</td>\n",
       "      <td>1935.34</td>\n",
       "      <td>2018-03-05 21:40:10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>672390</td>\n",
       "      <td>Kuhn-Gusikowski</td>\n",
       "      <td>S1-50961</td>\n",
       "      <td>34</td>\n",
       "      <td>48.20</td>\n",
       "      <td>1638.80</td>\n",
       "      <td>2018-03-06 11:59:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   account number             name       sku  quantity  unit price  ext price  \\\n",
       "0          412290    Jerde-Hilpert  S2-77896        43       76.66    3296.38   \n",
       "1          383080         Will LLC  S1-93683        28       90.86    2544.08   \n",
       "2          729833        Koepp Ltd  S1-30248        13       44.84     582.92   \n",
       "3          424914    White-Trantow  S2-82423        38       50.93    1935.34   \n",
       "4          672390  Kuhn-Gusikowski  S1-50961        34       48.20    1638.80   \n",
       "\n",
       "                 date  \n",
       "0 2018-03-04 23:10:28  \n",
       "1 2018-03-05 05:11:49  \n",
       "2 2018-03-05 17:33:52  \n",
       "3 2018-03-05 21:40:10  \n",
       "4 2018-03-06 11:59:00  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_dfs['Sheet1'].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>account number</th>\n",
       "      <th>name</th>\n",
       "      <th>sku</th>\n",
       "      <th>quantity</th>\n",
       "      <th>unit price</th>\n",
       "      <th>ext price</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>740150</td>\n",
       "      <td>Barton LLC</td>\n",
       "      <td>B1-20000</td>\n",
       "      <td>39</td>\n",
       "      <td>86.69</td>\n",
       "      <td>3380.91</td>\n",
       "      <td>2018-01-01 07:21:51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>714466</td>\n",
       "      <td>Trantow-Barrows</td>\n",
       "      <td>S2-77896</td>\n",
       "      <td>-1</td>\n",
       "      <td>63.16</td>\n",
       "      <td>-63.16</td>\n",
       "      <td>2018-01-01 10:00:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>218895</td>\n",
       "      <td>Kulas Inc</td>\n",
       "      <td>B1-69924</td>\n",
       "      <td>23</td>\n",
       "      <td>90.70</td>\n",
       "      <td>2086.10</td>\n",
       "      <td>2018-01-01 13:24:58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>307599</td>\n",
       "      <td>Kassulke, Ondricka and Metz</td>\n",
       "      <td>S1-65481</td>\n",
       "      <td>41</td>\n",
       "      <td>21.05</td>\n",
       "      <td>863.05</td>\n",
       "      <td>2018-01-01 15:05:22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>412290</td>\n",
       "      <td>Jerde-Hilpert</td>\n",
       "      <td>S2-34077</td>\n",
       "      <td>6</td>\n",
       "      <td>83.21</td>\n",
       "      <td>499.26</td>\n",
       "      <td>2018-01-01 23:26:55</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   account number                         name       sku  quantity  \\\n",
       "0          740150                   Barton LLC  B1-20000        39   \n",
       "1          714466              Trantow-Barrows  S2-77896        -1   \n",
       "2          218895                    Kulas Inc  B1-69924        23   \n",
       "3          307599  Kassulke, Ondricka and Metz  S1-65481        41   \n",
       "4          412290                Jerde-Hilpert  S2-34077         6   \n",
       "\n",
       "   unit price  ext price                date  \n",
       "0       86.69    3380.91 2018-01-01 07:21:51  \n",
       "1       63.16     -63.16 2018-01-01 10:00:47  \n",
       "2       90.70    2086.10 2018-01-01 13:24:58  \n",
       "3       21.05     863.05 2018-01-01 15:05:22  \n",
       "4       83.21     499.26 2018-01-01 23:26:55  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_dfs['Sheet2'].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Sheet1 - (39, 7)\n",
      "Sheet2 - (35, 7)\n",
      "Sheet3 - (47, 7)\n",
      "Sheet4 - (47, 7)\n",
      "Sheet5 - (81, 7)\n",
      "Sheet6 - (50, 7)\n"
     ]
    }
   ],
   "source": [
    "for sheet in all_dfs:\n",
    "    print(f\"{sheet} - {all_dfs[sheet].shape}\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.concat(all_dfs)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(299, 7)"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>account number</th>\n",
       "      <th>name</th>\n",
       "      <th>sku</th>\n",
       "      <th>quantity</th>\n",
       "      <th>unit price</th>\n",
       "      <th>ext price</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">Sheet1</th>\n",
       "      <th>0</th>\n",
       "      <td>412290</td>\n",
       "      <td>Jerde-Hilpert</td>\n",
       "      <td>S2-77896</td>\n",
       "      <td>43</td>\n",
       "      <td>76.66</td>\n",
       "      <td>3296.38</td>\n",
       "      <td>2018-03-04 23:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>383080</td>\n",
       "      <td>Will LLC</td>\n",
       "      <td>S1-93683</td>\n",
       "      <td>28</td>\n",
       "      <td>90.86</td>\n",
       "      <td>2544.08</td>\n",
       "      <td>2018-03-05 05:11:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>729833</td>\n",
       "      <td>Koepp Ltd</td>\n",
       "      <td>S1-30248</td>\n",
       "      <td>13</td>\n",
       "      <td>44.84</td>\n",
       "      <td>582.92</td>\n",
       "      <td>2018-03-05 17:33:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>424914</td>\n",
       "      <td>White-Trantow</td>\n",
       "      <td>S2-82423</td>\n",
       "      <td>38</td>\n",
       "      <td>50.93</td>\n",
       "      <td>1935.34</td>\n",
       "      <td>2018-03-05 21:40:10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>672390</td>\n",
       "      <td>Kuhn-Gusikowski</td>\n",
       "      <td>S1-50961</td>\n",
       "      <td>34</td>\n",
       "      <td>48.20</td>\n",
       "      <td>1638.80</td>\n",
       "      <td>2018-03-06 11:59:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          account number             name       sku  quantity  unit price  \\\n",
       "Sheet1 0          412290    Jerde-Hilpert  S2-77896        43       76.66   \n",
       "       1          383080         Will LLC  S1-93683        28       90.86   \n",
       "       2          729833        Koepp Ltd  S1-30248        13       44.84   \n",
       "       3          424914    White-Trantow  S2-82423        38       50.93   \n",
       "       4          672390  Kuhn-Gusikowski  S1-50961        34       48.20   \n",
       "\n",
       "          ext price                date  \n",
       "Sheet1 0    3296.38 2018-03-04 23:10:28  \n",
       "       1    2544.08 2018-03-05 05:11:49  \n",
       "       2     582.92 2018-03-05 17:33:52  \n",
       "       3    1935.34 2018-03-05 21:40:10  \n",
       "       4    1638.80 2018-03-06 11:59:00  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>account number</th>\n",
       "      <th>name</th>\n",
       "      <th>sku</th>\n",
       "      <th>quantity</th>\n",
       "      <th>unit price</th>\n",
       "      <th>ext price</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">Sheet6</th>\n",
       "      <th>45</th>\n",
       "      <td>239344</td>\n",
       "      <td>Stokes LLC</td>\n",
       "      <td>S1-82801</td>\n",
       "      <td>41</td>\n",
       "      <td>78.90</td>\n",
       "      <td>3234.90</td>\n",
       "      <td>2018-03-04 01:06:20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>218895</td>\n",
       "      <td>Kulas Inc</td>\n",
       "      <td>S2-78676</td>\n",
       "      <td>38</td>\n",
       "      <td>89.02</td>\n",
       "      <td>3382.76</td>\n",
       "      <td>2018-03-04 01:17:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>642753</td>\n",
       "      <td>Pollich LLC</td>\n",
       "      <td>S2-10342</td>\n",
       "      <td>40</td>\n",
       "      <td>56.85</td>\n",
       "      <td>2274.00</td>\n",
       "      <td>2018-03-04 01:49:22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>737550</td>\n",
       "      <td>Fritsch, Russel and Anderson</td>\n",
       "      <td>S2-83881</td>\n",
       "      <td>12</td>\n",
       "      <td>63.60</td>\n",
       "      <td>763.20</td>\n",
       "      <td>2018-03-04 15:26:20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>146832</td>\n",
       "      <td>Kiehn-Spinka</td>\n",
       "      <td>B1-53636</td>\n",
       "      <td>5</td>\n",
       "      <td>72.16</td>\n",
       "      <td>360.80</td>\n",
       "      <td>2018-03-04 21:18:04</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           account number                          name       sku  quantity  \\\n",
       "Sheet6 45          239344                    Stokes LLC  S1-82801        41   \n",
       "       46          218895                     Kulas Inc  S2-78676        38   \n",
       "       47          642753                   Pollich LLC  S2-10342        40   \n",
       "       48          737550  Fritsch, Russel and Anderson  S2-83881        12   \n",
       "       49          146832                  Kiehn-Spinka  B1-53636         5   \n",
       "\n",
       "           unit price  ext price                date  \n",
       "Sheet6 45       78.90    3234.90 2018-03-04 01:06:20  \n",
       "       46       89.02    3382.76 2018-03-04 01:17:11  \n",
       "       47       56.85    2274.00 2018-03-04 01:49:22  \n",
       "       48       63.60     763.20 2018-03-04 15:26:20  \n",
       "       49       72.16     360.80 2018-03-04 21:18:04  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>account number</th>\n",
       "      <th>name</th>\n",
       "      <th>sku</th>\n",
       "      <th>quantity</th>\n",
       "      <th>unit price</th>\n",
       "      <th>ext price</th>\n",
       "      <th>date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>412290</td>\n",
       "      <td>Jerde-Hilpert</td>\n",
       "      <td>S2-77896</td>\n",
       "      <td>43</td>\n",
       "      <td>76.66</td>\n",
       "      <td>3296.38</td>\n",
       "      <td>2018-03-04 23:10:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>383080</td>\n",
       "      <td>Will LLC</td>\n",
       "      <td>S1-93683</td>\n",
       "      <td>28</td>\n",
       "      <td>90.86</td>\n",
       "      <td>2544.08</td>\n",
       "      <td>2018-03-05 05:11:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>729833</td>\n",
       "      <td>Koepp Ltd</td>\n",
       "      <td>S1-30248</td>\n",
       "      <td>13</td>\n",
       "      <td>44.84</td>\n",
       "      <td>582.92</td>\n",
       "      <td>2018-03-05 17:33:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>424914</td>\n",
       "      <td>White-Trantow</td>\n",
       "      <td>S2-82423</td>\n",
       "      <td>38</td>\n",
       "      <td>50.93</td>\n",
       "      <td>1935.34</td>\n",
       "      <td>2018-03-05 21:40:10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>672390</td>\n",
       "      <td>Kuhn-Gusikowski</td>\n",
       "      <td>S1-50961</td>\n",
       "      <td>34</td>\n",
       "      <td>48.20</td>\n",
       "      <td>1638.80</td>\n",
       "      <td>2018-03-06 11:59:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>239344</td>\n",
       "      <td>Stokes LLC</td>\n",
       "      <td>S2-10342</td>\n",
       "      <td>34</td>\n",
       "      <td>36.93</td>\n",
       "      <td>1255.62</td>\n",
       "      <td>2018-03-06 23:49:16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>218895</td>\n",
       "      <td>Kulas Inc</td>\n",
       "      <td>S2-34077</td>\n",
       "      <td>30</td>\n",
       "      <td>99.73</td>\n",
       "      <td>2991.90</td>\n",
       "      <td>2018-03-07 05:15:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>672390</td>\n",
       "      <td>Kuhn-Gusikowski</td>\n",
       "      <td>B1-05914</td>\n",
       "      <td>25</td>\n",
       "      <td>89.86</td>\n",
       "      <td>2246.50</td>\n",
       "      <td>2018-03-07 06:25:52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>740150</td>\n",
       "      <td>Barton LLC</td>\n",
       "      <td>S1-82801</td>\n",
       "      <td>29</td>\n",
       "      <td>60.81</td>\n",
       "      <td>1763.49</td>\n",
       "      <td>2018-03-07 10:24:54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>218895</td>\n",
       "      <td>Kulas Inc</td>\n",
       "      <td>B1-20000</td>\n",
       "      <td>23</td>\n",
       "      <td>99.57</td>\n",
       "      <td>2290.11</td>\n",
       "      <td>2018-03-07 13:34:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>257198</td>\n",
       "      <td>Cronin, Oberbrunner and Spencer</td>\n",
       "      <td>S1-30248</td>\n",
       "      <td>14</td>\n",
       "      <td>91.37</td>\n",
       "      <td>1279.18</td>\n",
       "      <td>2018-03-07 16:21:58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>672390</td>\n",
       "      <td>Kuhn-Gusikowski</td>\n",
       "      <td>S2-83881</td>\n",
       "      <td>26</td>\n",
       "      <td>88.38</td>\n",
       "      <td>2297.88</td>\n",
       "      <td>2018-03-07 20:18:18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>424914</td>\n",
       "      <td>White-Trantow</td>\n",
       "      <td>B1-53636</td>\n",
       "      <td>44</td>\n",
       "      <td>59.93</td>\n",
       "      <td>2636.92</td>\n",
       "      <td>2018-03-07 21:16:24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>307599</td>\n",
       "      <td>Kassulke, Ondricka and Metz</td>\n",
       "      <td>S2-10342</td>\n",
       "      <td>4</td>\n",
       "      <td>12.99</td>\n",
       "      <td>51.96</td>\n",
       "      <td>2018-03-07 23:59:26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>383080</td>\n",
       "      <td>Will LLC</td>\n",
       "      <td>B1-20000</td>\n",
       "      <td>45</td>\n",
       "      <td>29.90</td>\n",
       "      <td>1345.50</td>\n",
       "      <td>2018-03-08 01:50:36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>527099</td>\n",
       "      <td>Sanford and Sons</td>\n",
       "      <td>S2-82423</td>\n",
       "      <td>44</td>\n",
       "      <td>23.30</td>\n",
       "      <td>1025.20</td>\n",
       "      <td>2018-03-09 00:18:55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>146832</td>\n",
       "      <td>Kiehn-Spinka</td>\n",
       "      <td>S2-77896</td>\n",
       "      <td>27</td>\n",
       "      <td>70.76</td>\n",
       "      <td>1910.52</td>\n",
       "      <td>2018-03-09 11:05:47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>642753</td>\n",
       "      <td>Pollich LLC</td>\n",
       "      <td>B1-05914</td>\n",
       "      <td>15</td>\n",
       "      <td>65.50</td>\n",
       "      <td>982.50</td>\n",
       "      <td>2018-03-09 11:22:09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>786968</td>\n",
       "      <td>Frami, Hills and Schmidt</td>\n",
       "      <td>S1-65481</td>\n",
       "      <td>14</td>\n",
       "      <td>44.67</td>\n",
       "      <td>625.38</td>\n",
       "      <td>2018-03-09 19:13:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>527099</td>\n",
       "      <td>Sanford and Sons</td>\n",
       "      <td>S1-82801</td>\n",
       "      <td>35</td>\n",
       "      <td>95.17</td>\n",
       "      <td>3330.95</td>\n",
       "      <td>2018-03-09 19:13:20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>257198</td>\n",
       "      <td>Cronin, Oberbrunner and Spencer</td>\n",
       "      <td>S2-23246</td>\n",
       "      <td>43</td>\n",
       "      <td>87.40</td>\n",
       "      <td>3758.20</td>\n",
       "      <td>2018-03-10 05:39:36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>527099</td>\n",
       "      <td>Sanford and Sons</td>\n",
       "      <td>B1-65551</td>\n",
       "      <td>6</td>\n",
       "      <td>58.04</td>\n",
       "      <td>348.24</td>\n",
       "      <td>2018-03-10 05:52:17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>218895</td>\n",
       "      <td>Kulas Inc</td>\n",
       "      <td>S1-47412</td>\n",
       "      <td>21</td>\n",
       "      <td>94.45</td>\n",
       "      <td>1983.45</td>\n",
       "      <td>2018-03-10 11:02:14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>729833</td>\n",
       "      <td>Koepp Ltd</td>\n",
       "      <td>S2-10342</td>\n",
       "      <td>12</td>\n",
       "      <td>93.64</td>\n",
       "      <td>1123.68</td>\n",
       "      <td>2018-03-10 13:08:45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>412290</td>\n",
       "      <td>Jerde-Hilpert</td>\n",
       "      <td>S1-82801</td>\n",
       "      <td>26</td>\n",
       "      <td>74.79</td>\n",
       "      <td>1944.54</td>\n",
       "      <td>2018-03-11 02:49:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>642753</td>\n",
       "      <td>Pollich LLC</td>\n",
       "      <td>S2-77896</td>\n",
       "      <td>13</td>\n",
       "      <td>48.14</td>\n",
       "      <td>625.82</td>\n",
       "      <td>2018-03-11 06:19:26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>218895</td>\n",
       "      <td>Kulas Inc</td>\n",
       "      <td>B1-33364</td>\n",
       "      <td>17</td>\n",
       "      <td>93.01</td>\n",
       "      <td>1581.17</td>\n",
       "      <td>2018-03-11 08:20:57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>307599</td>\n",
       "      <td>Kassulke, Ondricka and Metz</td>\n",
       "      <td>S1-50961</td>\n",
       "      <td>28</td>\n",
       "      <td>34.87</td>\n",
       "      <td>976.36</td>\n",
       "      <td>2018-03-11 10:49:24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>146832</td>\n",
       "      <td>Kiehn-Spinka</td>\n",
       "      <td>S1-93683</td>\n",
       "      <td>17</td>\n",
       "      <td>10.63</td>\n",
       "      <td>180.71</td>\n",
       "      <td>2018-03-11 12:43:03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>383080</td>\n",
       "      <td>Will LLC</td>\n",
       "      <td>S1-82801</td>\n",
       "      <td>3</td>\n",
       "      <td>77.06</td>\n",
       "      <td>231.18</td>\n",
       "      <td>2018-03-11 16:38:10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>269</th>\n",
       "      <td>141962</td>\n",
       "      <td>Herman LLC</td>\n",
       "      <td>B1-69924</td>\n",
       "      <td>21</td>\n",
       "      <td>95.00</td>\n",
       "      <td>1995.00</td>\n",
       "      <td>2018-02-26 19:08:02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270</th>\n",
       "      <td>383080</td>\n",
       "      <td>Will LLC</td>\n",
       "      <td>S2-23246</td>\n",
       "      <td>47</td>\n",
       "      <td>10.93</td>\n",
       "      <td>513.71</td>\n",
       "      <td>2018-02-26 20:41:02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271</th>\n",
       "      <td>383080</td>\n",
       "      <td>Will LLC</td>\n",
       "      <td>B1-20000</td>\n",
       "      <td>4</td>\n",
       "      <td>35.04</td>\n",
       "      <td>140.16</td>\n",
       "      <td>2018-02-26 23:56:15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272</th>\n",
       "      <td>672390</td>\n",
       "      <td>Kuhn-Gusikowski</td>\n",
       "      <td>S1-93683</td>\n",
       "      <td>10</td>\n",
       "      <td>34.96</td>\n",
       "      <td>349.60</td>\n",
       "      <td>2018-02-27 02:58:58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273</th>\n",
       "      <td>424914</td>\n",
       "      <td>White-Trantow</td>\n",
       "      <td>S1-93683</td>\n",
       "      <td>-1</td>\n",
       "      <td>25.01</td>\n",
       "      <td>-25.01</td>\n",
       "      <td>2018-02-27 10:32:25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274</th>\n",
       "      <td>383080</td>\n",
       "      <td>Will LLC</td>\n",
       "      <td>S1-93683</td>\n",
       "      <td>41</td>\n",
       "      <td>97.29</td>\n",
       "      <td>3988.89</td>\n",
       "      <td>2018-02-27 14:54:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>275</th>\n",
       "      <td>714466</td>\n",
       "      <td>Trantow-Barrows</td>\n",
       "      <td>S2-11481</td>\n",
       "      <td>46</td>\n",
       "      <td>39.61</td>\n",
       "      <td>1822.06</td>\n",
       "      <td>2018-02-27 16:12:51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276</th>\n",
       "      <td>740150</td>\n",
       "      <td>Barton LLC</td>\n",
       "      <td>S1-30248</td>\n",
       "      <td>21</td>\n",
       "      <td>14.05</td>\n",
       "      <td>295.05</td>\n",
       "      <td>2018-02-28 02:29:03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>277</th>\n",
       "      <td>218895</td>\n",
       "      <td>Kulas Inc</td>\n",
       "      <td>B1-69924</td>\n",
       "      <td>44</td>\n",
       "      <td>72.43</td>\n",
       "      <td>3186.92</td>\n",
       "      <td>2018-02-28 08:42:56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278</th>\n",
       "      <td>383080</td>\n",
       "      <td>Will LLC</td>\n",
       "      <td>B1-53102</td>\n",
       "      <td>6</td>\n",
       "      <td>32.80</td>\n",
       "      <td>196.80</td>\n",
       "      <td>2018-02-28 17:35:23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>688981</td>\n",
       "      <td>Keeling LLC</td>\n",
       "      <td>S2-23246</td>\n",
       "      <td>18</td>\n",
       "      <td>64.71</td>\n",
       "      <td>1164.78</td>\n",
       "      <td>2018-02-28 23:21:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>280</th>\n",
       "      <td>642753</td>\n",
       "      <td>Pollich LLC</td>\n",
       "      <td>B1-04202</td>\n",
       "      <td>8</td>\n",
       "      <td>95.86</td>\n",
       "      <td>766.88</td>\n",
       "      <td>2018-02-28 23:47:32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>281</th>\n",
       "      <td>163416</td>\n",
       "      <td>Purdy-Kunde</td>\n",
       "      <td>S1-30248</td>\n",
       "      <td>19</td>\n",
       "      <td>65.03</td>\n",
       "      <td>1235.57</td>\n",
       "      <td>2018-03-01 16:07:40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282</th>\n",
       "      <td>527099</td>\n",
       "      <td>Sanford and Sons</td>\n",
       "      <td>S2-82423</td>\n",
       "      <td>3</td>\n",
       "      <td>76.21</td>\n",
       "      <td>228.63</td>\n",
       "      <td>2018-03-01 17:18:01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>283</th>\n",
       "      <td>527099</td>\n",
       "      <td>Sanford and Sons</td>\n",
       "      <td>B1-50809</td>\n",
       "      <td>8</td>\n",
       "      <td>70.78</td>\n",
       "      <td>566.24</td>\n",
       "      <td>2018-03-01 18:53:09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284</th>\n",
       "      <td>737550</td>\n",
       "      <td>Fritsch, Russel and Anderson</td>\n",
       "      <td>B1-50809</td>\n",
       "      <td>20</td>\n",
       "      <td>50.11</td>\n",
       "      <td>1002.20</td>\n",
       "      <td>2018-03-01 23:47:17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285</th>\n",
       "      <td>688981</td>\n",
       "      <td>Keeling LLC</td>\n",
       "      <td>B1-86481</td>\n",
       "      <td>-1</td>\n",
       "      <td>97.16</td>\n",
       "      <td>-97.16</td>\n",
       "      <td>2018-03-02 01:46:44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>286</th>\n",
       "      <td>729833</td>\n",
       "      <td>Koepp Ltd</td>\n",
       "      <td>S1-82801</td>\n",
       "      <td>26</td>\n",
       "      <td>50.29</td>\n",
       "      <td>1307.54</td>\n",
       "      <td>2018-03-02 02:59:26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287</th>\n",
       "      <td>307599</td>\n",
       "      <td>Kassulke, Ondricka and Metz</td>\n",
       "      <td>S1-93683</td>\n",
       "      <td>-1</td>\n",
       "      <td>86.38</td>\n",
       "      <td>-86.38</td>\n",
       "      <td>2018-03-02 03:29:04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>288</th>\n",
       "      <td>412290</td>\n",
       "      <td>Jerde-Hilpert</td>\n",
       "      <td>S2-23246</td>\n",
       "      <td>27</td>\n",
       "      <td>58.87</td>\n",
       "      <td>1589.49</td>\n",
       "      <td>2018-03-02 12:10:30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289</th>\n",
       "      <td>307599</td>\n",
       "      <td>Kassulke, Ondricka and Metz</td>\n",
       "      <td>S2-34077</td>\n",
       "      <td>48</td>\n",
       "      <td>53.36</td>\n",
       "      <td>2561.28</td>\n",
       "      <td>2018-03-02 14:12:28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>290</th>\n",
       "      <td>141962</td>\n",
       "      <td>Herman LLC</td>\n",
       "      <td>S2-10342</td>\n",
       "      <td>49</td>\n",
       "      <td>31.39</td>\n",
       "      <td>1538.11</td>\n",
       "      <td>2018-03-02 23:08:02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291</th>\n",
       "      <td>257198</td>\n",
       "      <td>Cronin, Oberbrunner and Spencer</td>\n",
       "      <td>S2-16558</td>\n",
       "      <td>7</td>\n",
       "      <td>26.21</td>\n",
       "      <td>183.47</td>\n",
       "      <td>2018-03-03 00:29:24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>292</th>\n",
       "      <td>257198</td>\n",
       "      <td>Cronin, Oberbrunner and Spencer</td>\n",
       "      <td>S2-23246</td>\n",
       "      <td>40</td>\n",
       "      <td>49.19</td>\n",
       "      <td>1967.60</td>\n",
       "      <td>2018-03-03 10:17:24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>293</th>\n",
       "      <td>688981</td>\n",
       "      <td>Keeling LLC</td>\n",
       "      <td>B1-38851</td>\n",
       "      <td>25</td>\n",
       "      <td>74.68</td>\n",
       "      <td>1867.00</td>\n",
       "      <td>2018-03-03 18:18:54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>239344</td>\n",
       "      <td>Stokes LLC</td>\n",
       "      <td>S1-82801</td>\n",
       "      <td>41</td>\n",
       "      <td>78.90</td>\n",
       "      <td>3234.90</td>\n",
       "      <td>2018-03-04 01:06:20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>295</th>\n",
       "      <td>218895</td>\n",
       "      <td>Kulas Inc</td>\n",
       "      <td>S2-78676</td>\n",
       "      <td>38</td>\n",
       "      <td>89.02</td>\n",
       "      <td>3382.76</td>\n",
       "      <td>2018-03-04 01:17:11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>296</th>\n",
       "      <td>642753</td>\n",
       "      <td>Pollich LLC</td>\n",
       "      <td>S2-10342</td>\n",
       "      <td>40</td>\n",
       "      <td>56.85</td>\n",
       "      <td>2274.00</td>\n",
       "      <td>2018-03-04 01:49:22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>297</th>\n",
       "      <td>737550</td>\n",
       "      <td>Fritsch, Russel and Anderson</td>\n",
       "      <td>S2-83881</td>\n",
       "      <td>12</td>\n",
       "      <td>63.60</td>\n",
       "      <td>763.20</td>\n",
       "      <td>2018-03-04 15:26:20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>146832</td>\n",
       "      <td>Kiehn-Spinka</td>\n",
       "      <td>B1-53636</td>\n",
       "      <td>5</td>\n",
       "      <td>72.16</td>\n",
       "      <td>360.80</td>\n",
       "      <td>2018-03-04 21:18:04</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>299 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     account number                             name       sku  quantity  \\\n",
       "0            412290                    Jerde-Hilpert  S2-77896        43   \n",
       "1            383080                         Will LLC  S1-93683        28   \n",
       "2            729833                        Koepp Ltd  S1-30248        13   \n",
       "3            424914                    White-Trantow  S2-82423        38   \n",
       "4            672390                  Kuhn-Gusikowski  S1-50961        34   \n",
       "5            239344                       Stokes LLC  S2-10342        34   \n",
       "6            218895                        Kulas Inc  S2-34077        30   \n",
       "7            672390                  Kuhn-Gusikowski  B1-05914        25   \n",
       "8            740150                       Barton LLC  S1-82801        29   \n",
       "9            218895                        Kulas Inc  B1-20000        23   \n",
       "10           257198  Cronin, Oberbrunner and Spencer  S1-30248        14   \n",
       "11           672390                  Kuhn-Gusikowski  S2-83881        26   \n",
       "12           424914                    White-Trantow  B1-53636        44   \n",
       "13           307599      Kassulke, Ondricka and Metz  S2-10342         4   \n",
       "14           383080                         Will LLC  B1-20000        45   \n",
       "15           527099                 Sanford and Sons  S2-82423        44   \n",
       "16           146832                     Kiehn-Spinka  S2-77896        27   \n",
       "17           642753                      Pollich LLC  B1-05914        15   \n",
       "18           786968         Frami, Hills and Schmidt  S1-65481        14   \n",
       "19           527099                 Sanford and Sons  S1-82801        35   \n",
       "20           257198  Cronin, Oberbrunner and Spencer  S2-23246        43   \n",
       "21           527099                 Sanford and Sons  B1-65551         6   \n",
       "22           218895                        Kulas Inc  S1-47412        21   \n",
       "23           729833                        Koepp Ltd  S2-10342        12   \n",
       "24           412290                    Jerde-Hilpert  S1-82801        26   \n",
       "25           642753                      Pollich LLC  S2-77896        13   \n",
       "26           218895                        Kulas Inc  B1-33364        17   \n",
       "27           307599      Kassulke, Ondricka and Metz  S1-50961        28   \n",
       "28           146832                     Kiehn-Spinka  S1-93683        17   \n",
       "29           383080                         Will LLC  S1-82801         3   \n",
       "..              ...                              ...       ...       ...   \n",
       "269          141962                       Herman LLC  B1-69924        21   \n",
       "270          383080                         Will LLC  S2-23246        47   \n",
       "271          383080                         Will LLC  B1-20000         4   \n",
       "272          672390                  Kuhn-Gusikowski  S1-93683        10   \n",
       "273          424914                    White-Trantow  S1-93683        -1   \n",
       "274          383080                         Will LLC  S1-93683        41   \n",
       "275          714466                  Trantow-Barrows  S2-11481        46   \n",
       "276          740150                       Barton LLC  S1-30248        21   \n",
       "277          218895                        Kulas Inc  B1-69924        44   \n",
       "278          383080                         Will LLC  B1-53102         6   \n",
       "279          688981                      Keeling LLC  S2-23246        18   \n",
       "280          642753                      Pollich LLC  B1-04202         8   \n",
       "281          163416                      Purdy-Kunde  S1-30248        19   \n",
       "282          527099                 Sanford and Sons  S2-82423         3   \n",
       "283          527099                 Sanford and Sons  B1-50809         8   \n",
       "284          737550     Fritsch, Russel and Anderson  B1-50809        20   \n",
       "285          688981                      Keeling LLC  B1-86481        -1   \n",
       "286          729833                        Koepp Ltd  S1-82801        26   \n",
       "287          307599      Kassulke, Ondricka and Metz  S1-93683        -1   \n",
       "288          412290                    Jerde-Hilpert  S2-23246        27   \n",
       "289          307599      Kassulke, Ondricka and Metz  S2-34077        48   \n",
       "290          141962                       Herman LLC  S2-10342        49   \n",
       "291          257198  Cronin, Oberbrunner and Spencer  S2-16558         7   \n",
       "292          257198  Cronin, Oberbrunner and Spencer  S2-23246        40   \n",
       "293          688981                      Keeling LLC  B1-38851        25   \n",
       "294          239344                       Stokes LLC  S1-82801        41   \n",
       "295          218895                        Kulas Inc  S2-78676        38   \n",
       "296          642753                      Pollich LLC  S2-10342        40   \n",
       "297          737550     Fritsch, Russel and Anderson  S2-83881        12   \n",
       "298          146832                     Kiehn-Spinka  B1-53636         5   \n",
       "\n",
       "     unit price  ext price                date  \n",
       "0         76.66    3296.38 2018-03-04 23:10:28  \n",
       "1         90.86    2544.08 2018-03-05 05:11:49  \n",
       "2         44.84     582.92 2018-03-05 17:33:52  \n",
       "3         50.93    1935.34 2018-03-05 21:40:10  \n",
       "4         48.20    1638.80 2018-03-06 11:59:00  \n",
       "5         36.93    1255.62 2018-03-06 23:49:16  \n",
       "6         99.73    2991.90 2018-03-07 05:15:29  \n",
       "7         89.86    2246.50 2018-03-07 06:25:52  \n",
       "8         60.81    1763.49 2018-03-07 10:24:54  \n",
       "9         99.57    2290.11 2018-03-07 13:34:00  \n",
       "10        91.37    1279.18 2018-03-07 16:21:58  \n",
       "11        88.38    2297.88 2018-03-07 20:18:18  \n",
       "12        59.93    2636.92 2018-03-07 21:16:24  \n",
       "13        12.99      51.96 2018-03-07 23:59:26  \n",
       "14        29.90    1345.50 2018-03-08 01:50:36  \n",
       "15        23.30    1025.20 2018-03-09 00:18:55  \n",
       "16        70.76    1910.52 2018-03-09 11:05:47  \n",
       "17        65.50     982.50 2018-03-09 11:22:09  \n",
       "18        44.67     625.38 2018-03-09 19:13:11  \n",
       "19        95.17    3330.95 2018-03-09 19:13:20  \n",
       "20        87.40    3758.20 2018-03-10 05:39:36  \n",
       "21        58.04     348.24 2018-03-10 05:52:17  \n",
       "22        94.45    1983.45 2018-03-10 11:02:14  \n",
       "23        93.64    1123.68 2018-03-10 13:08:45  \n",
       "24        74.79    1944.54 2018-03-11 02:49:11  \n",
       "25        48.14     625.82 2018-03-11 06:19:26  \n",
       "26        93.01    1581.17 2018-03-11 08:20:57  \n",
       "27        34.87     976.36 2018-03-11 10:49:24  \n",
       "28        10.63     180.71 2018-03-11 12:43:03  \n",
       "29        77.06     231.18 2018-03-11 16:38:10  \n",
       "..          ...        ...                 ...  \n",
       "269       95.00    1995.00 2018-02-26 19:08:02  \n",
       "270       10.93     513.71 2018-02-26 20:41:02  \n",
       "271       35.04     140.16 2018-02-26 23:56:15  \n",
       "272       34.96     349.60 2018-02-27 02:58:58  \n",
       "273       25.01     -25.01 2018-02-27 10:32:25  \n",
       "274       97.29    3988.89 2018-02-27 14:54:11  \n",
       "275       39.61    1822.06 2018-02-27 16:12:51  \n",
       "276       14.05     295.05 2018-02-28 02:29:03  \n",
       "277       72.43    3186.92 2018-02-28 08:42:56  \n",
       "278       32.80     196.80 2018-02-28 17:35:23  \n",
       "279       64.71    1164.78 2018-02-28 23:21:04  \n",
       "280       95.86     766.88 2018-02-28 23:47:32  \n",
       "281       65.03    1235.57 2018-03-01 16:07:40  \n",
       "282       76.21     228.63 2018-03-01 17:18:01  \n",
       "283       70.78     566.24 2018-03-01 18:53:09  \n",
       "284       50.11    1002.20 2018-03-01 23:47:17  \n",
       "285       97.16     -97.16 2018-03-02 01:46:44  \n",
       "286       50.29    1307.54 2018-03-02 02:59:26  \n",
       "287       86.38     -86.38 2018-03-02 03:29:04  \n",
       "288       58.87    1589.49 2018-03-02 12:10:30  \n",
       "289       53.36    2561.28 2018-03-02 14:12:28  \n",
       "290       31.39    1538.11 2018-03-02 23:08:02  \n",
       "291       26.21     183.47 2018-03-03 00:29:24  \n",
       "292       49.19    1967.60 2018-03-03 10:17:24  \n",
       "293       74.68    1867.00 2018-03-03 18:18:54  \n",
       "294       78.90    3234.90 2018-03-04 01:06:20  \n",
       "295       89.02    3382.76 2018-03-04 01:17:11  \n",
       "296       56.85    2274.00 2018-03-04 01:49:22  \n",
       "297       63.60     763.20 2018-03-04 15:26:20  \n",
       "298       72.16     360.80 2018-03-04 21:18:04  \n",
       "\n",
       "[299 rows x 7 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.concat(pd.read_excel(workbook_url, sheet_name=None), ignore_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
